/****** Object:  Stored Procedure dbo.GetPDFBlobBydocumentId  ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetPDFBlobByDocumentId]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[GetPDFBlobByDocumentId]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO    
/************************************************************************************************    
* Name:  GetPDFBlobByDocumentId                                                              
* Purpose: Stored procedure to fetch the Converted PDF Blob    
    
* PARAMETERS      
* Name							Description    
* -------------------------    -----------------------------    
* @documentId					documentId, whose blob was converted    
************************************************************************************************/    
CREATE PROCEDURE dbo.[GetPDFBlobByDocumentId]    
(    
 @documentid int      
)      
AS      
BEGIN      
 SET NOCOUNT ON      
      
 SELECT PDFBlob      
 FROM ConvertedPDFDocument      
 WHERE Documentid = @documentid      
      
 SET NOCOUNT OFF      
END      

